Jak v SQL dotazu ignorovat Case Sensitive ?

Otázka od: PETR KOREC

19. 9. 2002 16:31



Ahoj, poradi mi prosim nekdo jak v nasledujicim dotazu z Delphi do Oracle
dosahnout toho, aby pri porovnavani nezalezelo na velikosti pismen ?
Dik, Petr

SQL.Add('SELECT sablona FROM tism_objekty_implic WHERE (sablona= ' + #39
+EditImSablona.text + #39 + ')');

Odpovedá: Ben, Martin (CAP, GCF)

19. 9. 2002 16:56

Pouzit funkce Upper nebo Lower

SELECT sablona FROM tism_objekty_implic WHERE Upper(sablona) =
Upper('MojeSablona')


Martin Ben


> -----Original Message-----
> From: PETR KOREC [mailto:pkorec@ic-energo.cz]
>
> Ahoj, poradi mi prosim nekdo jak v nasledujicim dotazu z
> Delphi do Oracle
> dosahnout toho, aby pri porovnavani nezalezelo na velikosti pismen ?
> Dik, Petr
>
> SQL.Add('SELECT sablona FROM tism_objekty_implic WHERE
> (sablona= ' + #39
> +EditImSablona.text + #39 + ')');

Odpovedá: ViragI@logica.com

20. 9. 2002 15:22


SQL.Add('SELECT sablona FROM tism_objekty_implic WHERE upper(sablona)= ''' +
uppercase(EditImSablona.text)+'''')

nebo

SQL.Add('SELECT sablona FROM tism_objekty_implic WHERE upper(sablona)= ' +
''''+uppercase(Desc)+'''')

Ivan Virag

-----Original Message-----
From: PETR KOREC [mailto:pkorec@ic-energo.cz]
Sent: Thursday, September 19, 2002 5:03 PM
To: delphi-l@clexpert.cz
Subject: Jak v SQL dotazu ignorovat Case Sensitive ?




Ahoj, poradi mi prosim nekdo jak v nasledujicim dotazu z Delphi do Oracle
dosahnout toho, aby pri porovnavani nezalezelo na velikosti pismen ?
Dik, Petr

SQL.Add('SELECT sablona FROM tism_objekty_implic WHERE (sablona= ' + #39
+EditImSablona.text + #39 + ')');


This e-mail and any attachment is for authorised use by the intended
recipient(s) only. It may contain proprietary material, confidential
information and/or be subject to legal privilege. It should not be copied,
disclosed to, retained or used by, any other party. If you are not an intended
recipient then please promptly delete this e-mail and any attachment and all
copies and inform the sender. Thank you.